﻿using System;
namespace fanli.Model
{
	/// <summary>
	/// 礼品分类实体类：fanli_giftCata 。
	/// </summary>
	[Serializable]
	public class fanli_giftCata
	{
		public fanli_giftCata()
		{}

		#region Model
		private int _id; //id
		private int _parentID; //父类id
		private string _cataname; //类别名称
		private string _about; //说明
		private int _sortid; //排序


        /// <summary>
		/// id
		/// </summary>
		public int id
		{
			set{ _id=value;}
			get{return _id;}
		}
        /// <summary>
		/// 父类id
		/// </summary>
		public int parentID
		{
			set{ _parentID=value;}
			get{return _parentID;}
		}
        /// <summary>
		/// 类别名称
		/// </summary>
		public string cataname
		{
			set{ _cataname=value;}
			get{return _cataname;}
		}
        /// <summary>
		/// 说明
		/// </summary>
		public string about
		{
			set{ _about=value;}
			get{return _about;}
		}
        /// <summary>
		/// 排序
		/// </summary>
		public int sortid
		{
			set{ _sortid=value;}
			get{return _sortid;}
		}
		#endregion Model

		#region txt document
		/*
礼品分类,giftCata
id,父类id,类别名称,说明,排序
id,parentID,cataname,about,sortid
i,i,c20,c500,i

--------------------------
-- 创建表[礼品分类]开始: 
-- alter table  [fanli_giftCata] add
-- IF EXISTS (SELECT 1 FROM sysobjects WHERE xtype='u' AND name='fanli_giftCata') drop table fanli_giftCata
  CREATE TABLE [fanli_giftCata] (
	 [id] integer IDENTITY (1, 1) PRIMARY KEY NOT NULL ,
	 [parentID] int,
	 [cataname] [varchar] (20),
	 [about] [varchar] (500),
	 [sortid] int
  )

 exec sp_addextendedproperty N'MS_Description',N'礼品分类 ',N'user',N'dbo',N'table',N'fanli_giftCata', NULL, NULL
 exec sp_addextendedproperty N'MS_Description',N'id',N'user',N'dbo',N'table',N'fanli_giftCata',N'column',N'id'
 exec sp_addextendedproperty N'MS_Description',N'父类id',N'user',N'dbo',N'table',N'fanli_giftCata',N'column',N'parentID'
 exec sp_addextendedproperty N'MS_Description',N'类别名称',N'user',N'dbo',N'table',N'fanli_giftCata',N'column',N'cataname'
 exec sp_addextendedproperty N'MS_Description',N'说明',N'user',N'dbo',N'table',N'fanli_giftCata',N'column',N'about'
 exec sp_addextendedproperty N'MS_Description',N'排序',N'user',N'dbo',N'table',N'fanli_giftCata',N'column',N'sortid'

-- 创建表[礼品分类]结束。 
--------------------------

		*/
		#endregion document
	}
}

